SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and type ='T'
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Enjoy the convenience of condominium living at Reed Court! Located near all Upper Valley amenities and less than 2 miles to DHMC. This unit is filled with natural light and offers an open Kitchen, Dining and Living Room design. It is available for immediate occupancy and features 6 rooms, Primary bedroom suite, guest bedroom and office or another bedroom. Also included are central AC, interior sprinklers for fire suppression, attached finished garage, private yard and full basement.
Description:Welcome to your new home! This charming 2-bedroom/2 1/2 bath condo is within walking distance to downtown Hanover, Dartmouth College, and DHMC, offering the perfect blend of comfort and convenience. The cozy living room features hardwood floors and a brick fireplace, creating a warm and inviting atmosphere. It's connected to an open-concept kitchen and dining area, ideal for family gatherings. Upstairs, you'll find two bedrooms sharing a full bathroom. The master bedroom includes a stairway up to a spacious loft with large skylights, perfect for an office or cozy reading nook. The large finished basement has tile floors, a 3/4 bath, laundry with new washer/dryer, and a pellet stove that heats the entire unit in winter. Outside, there is a private rear deck, a shed, and a large lockable storage unit for extra belongings. Parking includes a carport and additional space. Schedule a viewing today to experience all this condo has to offer!
Description:New Price ......Fall in Love with History and Location™ Discover the best of village living in this Lyme Green Gem! This Circa 1816, desirably located condominium residence will offer you a unique blend of relaxation, tranquility and historical charm. The distinctive and charming first floor end unit boasts a second floor primary bedroom suite as well as a spacious first floor bedroom. Enhanced by stunning 1825 wide pine floors, original beams and custom built-ins throughout, this unit exuding warmth and and comfort. A delightful updated kitchen with sparkling new appliances and a 4 season sunporch overlooking a spacious backyard complete the package! Ideally located across from the Village Green, you'll find yourself just steps away from the country store, post office, banks , hardware store...and just around the corner from the Lyme School and town library. Delight in dining in the popular restaurants just steps away! ....And enjoy endless recreational activities in the hiking trails, ponds, river and the Dartmouth Skiway! Whether you are looking for your next home or a tranquil get away, this is your opportunity to experience the vibrant and welcoming community of Lyme. The perfect escape to simpler times, offering a bird's eye view of the charming 19th century village center. Fall in Love with History and Location™
Description:Showings begin at the open house on Saturday, March 8th, 10 am - 2 pm. Nestled in the heart of Hanover, just a short walk from Dartmouth College and downtown amenities, 107 Brook Hollow offers the perfect blend of convenience, comfort, and community. This desirable first-floor, three-bedroom, two-bathroom condo features an open-concept layout designed for effortless living. The inviting living room, complete with a cozy wood-burning stove, opens to a sunny deck overlooking Girl Brook, creating a serene space to relax and unwind. Enjoy direct access to scenic walking and recreational trails, perfect for outdoor enthusiasts. Additional highlights include reserved parking, ample interior and exterior storage, and shared community amenities such as a clubhouse and pool. Whether you're seeking a full-time residence, a Hanover pied-ŕ-terre, or a prime investment property, this Brook Hollow gem is an opportunity not to be missed. Showings begin at the open house on Saturday, March 8th, 10 am - 2 pm.